/*
 Navicat Premium Dump SQL

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80028 (8.0.28)
 Source Host           : localhost:3306
 Source Schema         : firelink_system

 Target Server Type    : MySQL
 Target Server Version : 80028 (8.0.28)
 File Encoding         : 65001

 Date: 20/02/2025 16:05:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for aerial_view_coordinate
-- ----------------------------
DROP TABLE IF EXISTS `aerial_view_coordinate`;
CREATE TABLE `aerial_view_coordinate` (
  `device_id` varchar(100) DEFAULT NULL COMMENT '设备ID',
  `user_id` varchar(36) DEFAULT NULL COMMENT '用户ID',
  `x` varchar(20) DEFAULT NULL COMMENT '横坐标',
  `y` varchar(20) DEFAULT NULL COMMENT '纵坐标',
  `device_name` varchar(100) DEFAULT NULL COMMENT '设备名称'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='鸟瞰图-坐标';

-- ----------------------------
-- Records of aerial_view_coordinate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for app_user_cid
-- ----------------------------
DROP TABLE IF EXISTS `app_user_cid`;
CREATE TABLE `app_user_cid` (
  `id` varchar(36) DEFAULT NULL COMMENT '用户id',
  `cid` varchar(100) DEFAULT NULL COMMENT 'app的cid',
  `accountname` varchar(30) DEFAULT NULL COMMENT '用户名'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of app_user_cid
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for appversion
-- ----------------------------
DROP TABLE IF EXISTS `appversion`;
CREATE TABLE `appversion` (
  `version_code` varchar(30) DEFAULT NULL COMMENT '版本号',
  `url` varchar(255) DEFAULT NULL COMMENT 'url',
  `remark` varchar(50) DEFAULT NULL COMMENT '备注',
  `sortid` int DEFAULT '0' COMMENT '版本号排序，越新的数目越大'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='app版本';

-- ----------------------------
-- Records of appversion
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` varchar(36) NOT NULL COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `des` varchar(50) DEFAULT NULL COMMENT '描述',
  `business_id` varchar(36) DEFAULT NULL COMMENT '单位id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='单位-部门表';

-- ----------------------------
-- Records of department
-- ----------------------------
BEGIN;
INSERT INTO `department` (`id`, `name`, `des`, `business_id`) VALUES ('f9bcbb8b-b494-4bdc-a5d2-8b28c091b779', '管理部门', NULL, '92c4f6a0-cc19-47f8-a304-6fc48550f0fe');
COMMIT;

-- ----------------------------
-- Table structure for device_wechat
-- ----------------------------
DROP TABLE IF EXISTS `device_wechat`;
CREATE TABLE `device_wechat` (
  `id` varchar(36) NOT NULL COMMENT '主键id',
  `number` varchar(13) DEFAULT NULL COMMENT '设备号',
  `open_id` varchar(36) DEFAULT NULL COMMENT 'openid',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of device_wechat
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for dict
-- ----------------------------
DROP TABLE IF EXISTS `dict`;
CREATE TABLE `dict` (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '名称',
  `groupname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '组名',
  `sortid` int DEFAULT NULL COMMENT '排序字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='字典表';

-- ----------------------------
-- Records of dict
-- ----------------------------
BEGIN;
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '消防安全重点单位', '消防等级', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c902', '消防安全一般单位', '消防等级', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c903', '九小场所', '消防等级', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c904', '其它', '消防等级', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c905', '机关', '单位性质', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c906', '团体', '单位性质', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c907', '企业', '单位性质', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c908', '事业', '单位性质', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c909', '其它', '单位性质', 5);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c910', '会议通告', '通告类型', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c911', '奖惩通告', '通告类型', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c912', '活动通告', '通告类型', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c913', '其它', '通告类型', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c914', '电压报警', '电气火灾监测报警类型', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c915', '电流报警', '电气火灾监测报警类型', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c916', '温度报警', '电气火灾监测报警类型', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c917', '漏电流报警', '电气火灾监测报警类型', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c919', '消火栓', '建筑消防用水设备类型', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c920', '自动水喷淋', '建筑消防用水设备类型', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c921', '消防水池', '建筑消防用水设备类型', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c922', '高位水箱', '建筑消防用水设备类型', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c923', '液压报警', '建筑消防用水报警类型', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c924', '液位报警', '建筑消防用水报警类型', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c929', '年度工作任务', '检查类型', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c930', '月工作任务', '检查类型', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c931', '周工作任务', '检查类型', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c932', '临时工作任务', '检查类型', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c933', '专项工作任务', '检查类型', 5);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c934', '其它', '检查类型', 6);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c935', '平面图', '单位消防平面图类别', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c936', '疏散图', '单位消防平面图类别', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c937', '水电图', '单位消防平面图类别', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c938', '消防管网布局图', '单位消防平面图类别', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c939', '消防灭火设施划分区域图', '单位消防平面图类别', 5);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c940', '监管设备安装点位置图', '单位消防平面图类别', 6);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c941', '安全巡检区域图', '单位消防平面图类别', 7);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c942', '安全教育培训制度', '单位规章制度类型', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c943', '防火巡查检查制度', '单位规章制度类型', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c944', '安全疏散设施管理制度', '单位规章制度类型', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c945', '消防（控制室）值班制度', '单位规章制度类型', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c946', '消防设施器材维护管理制度', '单位规章制度类型', 5);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c947', '火灾隐患整改制度', '单位规章制度类型', 6);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c948', '用火用电安全管理制度', '单位规章制度类型', 7);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c949', '易燃易爆危险物品和场所防火防爆制度', '单位规章制度类型', 8);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c950', '专职志愿消防队的组织管理制度', '单位规章制度类型', 9);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c951', '灭火和应急疏散预案演练制度', '单位规章制度类型', 10);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c952', '燃气电气设备的检查和管理制度', '单位规章制度类型', 11);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c953', '消防安全工作考评和奖惩制度', '单位规章制度类型', 12);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c954', '消防行政审批', '单位合法性文件类别', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c955', '消防竣工验收', '单位合法性文件类别', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c956', '开业前检查', '单位合法性文件类别', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c960', '待定', '隐患', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c961', '未定级', '隐患', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c962', '一般隐患', '隐患', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c963', '重大隐患', '隐患', 4);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c970', '烟雾报警', '智慧独立烟感报警类型', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c971', '信号异常报警', '智慧独立烟感报警类型', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c972', '火焰报警', '消防可视化监测报警类型', 1);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c973', '脱岗离岗报警', '消防可视化监测报警类型', 2);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c974', '消防通道报警', '消防可视化监测报警类型', 3);
INSERT INTO `dict` (`id`, `name`, `groupname`, `sortid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c975', '可燃气报警', '可燃气体监测报警类型', 1);
COMMIT;

-- ----------------------------
-- Table structure for frame_monitoring
-- ----------------------------
DROP TABLE IF EXISTS `frame_monitoring`;
CREATE TABLE `frame_monitoring` (
  `user_id` varchar(36) NOT NULL COMMENT '用户ID',
  `state` varchar(1) DEFAULT NULL COMMENT '是否开启  1开启 2关闭',
  `time` varchar(2) DEFAULT NULL COMMENT '时间分钟'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='处置弹框提示自定义';

-- ----------------------------
-- Records of frame_monitoring
-- ----------------------------
BEGIN;
INSERT INTO `frame_monitoring` (`user_id`, `state`, `time`) VALUES ('303a0f2c-e03d-42d6-ab3e-6f410bc8990c', '1', '5');
INSERT INTO `frame_monitoring` (`user_id`, `state`, `time`) VALUES ('c45f7cea-4271-411b-8135-887c798b9183', '1', '5');
INSERT INTO `frame_monitoring` (`user_id`, `state`, `time`) VALUES ('3807b99a-b038-42c9-a37c-00c232ab4b90', '2', '5');
COMMIT;

-- ----------------------------
-- Table structure for home_page_layout
-- ----------------------------
DROP TABLE IF EXISTS `home_page_layout`;
CREATE TABLE `home_page_layout` (
  `id` varchar(36) NOT NULL COMMENT '主键id',
  `subtitle_name` varchar(20) DEFAULT NULL COMMENT '小标题名称',
  `headline_name` varchar(20) DEFAULT NULL COMMENT '大标题名称',
  `home_id` varchar(36) DEFAULT NULL COMMENT '机构id',
  `logo` varchar(100) DEFAULT NULL COMMENT 'logo',
  `permissions_id` varchar(36) DEFAULT NULL COMMENT '展示id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='默认首页布局';

-- ----------------------------
-- Records of home_page_layout
-- ----------------------------
BEGIN;
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('001e7548-8735-4b31-b30b-c6541a62c155', '证书管理', '证书管理', NULL, 'https://www.hltong168.cn/img/index/certificate.png', '038');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('001e7548-8735-4b31-b30b-c6541a62c156', '应急指挥', '应急指挥', NULL, 'https://aq.wisdiot.com/img/index/emergency_command.png', '037');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6667', '通知公告', NULL, NULL, 'https://aq.wisdiot.com/img/index/horn.png', '001');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6668', '一企一档', NULL, NULL, 'https://aq.wisdiot.com/img/index/record.png', '002');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6669', '检查工作下发', NULL, NULL, 'https://aq.wisdiot.com/img/index/work.png', '003');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6670', '检查工作落实', NULL, NULL, 'https://aq.wisdiot.com/img/index/task.png', '004');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6671', '巡检巡查', NULL, NULL, 'https://aq.wisdiot.com/img/index/routing.png', '005');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6672', '系统设置', NULL, NULL, 'https://aq.wisdiot.com/img/index/setting.png', '006');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6673', '安全值守平台', '安全值守平台', NULL, 'https://aq.wisdiot.com/img/index/iot.png', '007');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6674', '电气火灾监测', '电气火灾监测系统', NULL, 'https://aq.wisdiot.com/img/index/fire.png', '008');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6675', '建筑消防用水', '建筑用水监测系统', NULL, 'https://aq.wisdiot.com/img/index/pool.png', '009');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6676', '智慧独立烟感', '独立烟感监测系统', NULL, 'https://aq.wisdiot.com/img/index/smoke.png', '010');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6677', '气体监测系统', '气体监测系统', NULL, 'https://aq.wisdiot.com/img/index/gas.png', '012');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6678', '自动联网报警', '自动联网报警', NULL, 'https://aq.wisdiot.com/img/index/warn.png', '015');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6679', '智慧融媒体', NULL, NULL, 'https://aq.wisdiot.com/img/index/led.png', '013');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6680', '智能灭火系统', '智能灭火系统', NULL, 'https://aq.wisdiot.com/img/index/fire-control.png', '014');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6681', '水泵监测系统', '水泵监测系统', NULL, 'https://aq.wisdiot.com/img/index/waterpump.png', '016');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6682', '慧眼识别', '慧眼识别', NULL, 'https://aq.wisdiot.com/img/index/eyerecognition.png', '023');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6683', '电梯安全', '电梯安全', NULL, 'https://aq.wisdiot.com/img/index/Smartladdercontrol.png', '021');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6684', '危化品企业安全', '危化品企业安全', NULL, 'https://aq.wisdiot.com/img/index/gasstation.png', '020');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6685', '水域安全', '水域安全', NULL, 'https://aq.wisdiot.com/img/index/Intelligentwaters.png', '022');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6686', '医院安全', '医院安全', NULL, 'https://aq.wisdiot.com/img/index/PublicHealth.png', '024');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6687', '可视视频', '可视视频', NULL, 'https://aq.wisdiot.com/img/index/Visualvideo.png', '025');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6688', '厨房安全', '厨房安全', NULL, 'https://aq.wisdiot.com/img/index/Brightkitchen.png', '026');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6689', '综合治理可视化', '综合治理可视化', NULL, 'https://aq.wisdiot.com/img/index/comprehensivecontrol.png', '011');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6690', '物联设备管理', '', NULL, 'https://aq.wisdiot.com/img/index/device.png', '017');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6691', '历史报警信息', NULL, NULL, 'https://aq.wisdiot.com/img/index/time.png', '018');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6692', '大数据分析', NULL, NULL, 'https://aq.wisdiot.com/img/index/analysis.png', '019');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6694', '检查痕迹', NULL, NULL, 'https://aq.wisdiot.com/img/index/routing.png', '028');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6695', '消防档案', NULL, NULL, 'https://aq.wisdiot.com/img/index/record.png', '029');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6696', '公共环境安全监管云平台', NULL, NULL, '', '000');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6697', '应知应会', NULL, NULL, 'https://aq.wisdiot.com/img/index/xx.png', '030');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('00595746-b5d8-409a-bfc4-f204123e6698', '远程抄表', NULL, NULL, 'https://aq.wisdiot.com/img/index/ultrasonic.png', '032');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('f4211916-c3de-400a-a7b4-9188b4972e11', '开关量监测系统', '开关量监测系统', '', 'https://aq.wisdiot.com/img/index/switch.png', '033');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('f4211916-c3de-400a-a7b4-9188b4972e13', '仓库安全', '仓库安全', '', 'https://aq.wisdiot.com/img/index/warehouse.png', '035');
INSERT INTO `home_page_layout` (`id`, `subtitle_name`, `headline_name`, `home_id`, `logo`, `permissions_id`) VALUES ('f4211916-c3de-400a-a7b4-9188b4972e14', '充电桩安全', '充电桩安全', '', 'https://aq.wisdiot.com/img/index/charging_station.png', '036');
COMMIT;

-- ----------------------------
-- Table structure for home_page_layout_info
-- ----------------------------
DROP TABLE IF EXISTS `home_page_layout_info`;
CREATE TABLE `home_page_layout_info` (
  `id` varchar(36) NOT NULL COMMENT '主键id',
  `subtitle_name` varchar(20) DEFAULT NULL COMMENT '小标题名称',
  `headline_name` varchar(20) DEFAULT NULL COMMENT '大标题名称',
  `home_id` varchar(36) DEFAULT NULL COMMENT '机构id',
  `logo` varchar(100) DEFAULT NULL COMMENT 'logo',
  `permissions_id` varchar(36) DEFAULT NULL COMMENT '展示id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='机构自定义首页布局';

-- ----------------------------
-- Records of home_page_layout_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for large_screen_settings
-- ----------------------------
DROP TABLE IF EXISTS `large_screen_settings`;
CREATE TABLE `large_screen_settings` (
  `user_id` varchar(36) NOT NULL COMMENT '用户ID',
  `file` varchar(255) DEFAULT NULL COMMENT '文件地址',
  `type` int DEFAULT NULL COMMENT '类型： 1大屏背景 2 报警音频',
  `default_option` int DEFAULT NULL COMMENT '默认： 1地图 2背景 3混合'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='大屏设置';

-- ----------------------------
-- Records of large_screen_settings
-- ----------------------------
BEGIN;
INSERT INTO `large_screen_settings` (`user_id`, `file`, `type`, `default_option`) VALUES ('7f881829-1e1b-4bc0-9fd8-c8db33ea7f07', 'https://aq.wisdiot.com/uploads/file/20230420/1681983897938.jpg', 1, 2);
INSERT INTO `large_screen_settings` (`user_id`, `file`, `type`, `default_option`) VALUES ('ea0ca282-82af-4905-8033-0bfb5c343f24', 'https://aq.wisdiot.com/uploads/file/20230606/1686019329934.jpeg', 1, 2);
INSERT INTO `large_screen_settings` (`user_id`, `file`, `type`, `default_option`) VALUES ('0cf69841-4f47-43a9-bf52-9ed8d4014ee0', 'https://aq.wisdiot.com/uploads/file/20231030/1698648444760.png', 1, 2);
INSERT INTO `large_screen_settings` (`user_id`, `file`, `type`, `default_option`) VALUES ('ce9b5ca9-e86e-48f2-8cc0-e953eeac1115', 'https://aq.wisdiot.com/uploads/file/20240318/1710741932645.jpg', 1, 2);
INSERT INTO `large_screen_settings` (`user_id`, `file`, `type`, `default_option`) VALUES ('01148f38-27a7-4890-bd5e-c4c835dd2782', '', 1, 3);
INSERT INTO `large_screen_settings` (`user_id`, `file`, `type`, `default_option`) VALUES ('868f1d39-0bd9-4f92-abcc-4fff4bf65496', '', 1, 1);
INSERT INTO `large_screen_settings` (`user_id`, `file`, `type`, `default_option`) VALUES ('cb525aef-b192-4b3a-8ced-e79c789434df', '', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for organization
-- ----------------------------
DROP TABLE IF EXISTS `organization`;
CREATE TABLE `organization` (
  `id` varchar(36) NOT NULL COMMENT '主键id',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `pid` varchar(36) DEFAULT NULL COMMENT '父级id:所属机构的id',
  `des` varchar(255) DEFAULT NULL COMMENT '描述',
  `all_id` varchar(500) DEFAULT NULL COMMENT '上级及本级机构id；逗号分隔',
  `reginid` varchar(36) DEFAULT NULL COMMENT '最顶级行政区划id：只有每个区域的最顶级账号有这个字段值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='机构表';

-- ----------------------------
-- Records of organization
-- ----------------------------
BEGIN;
INSERT INTO `organization` (`id`, `name`, `pid`, `des`, `all_id`, `reginid`) VALUES ('0', '总部', '-1', '总部', '0', '0');
INSERT INTO `organization` (`id`, `name`, `pid`, `des`, `all_id`, `reginid`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c102', '总监管', '0', '总监管', '001e7548-8735-4b31-b30b-c9361a62c102', '0');
COMMIT;

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '名称',
  `pid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '父级id',
  `level` int DEFAULT NULL COMMENT '等级',
  `createtime` datetime DEFAULT NULL COMMENT '创建时间',
  `sortid` int DEFAULT NULL COMMENT '排序字段',
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '可见用户类型：1总账号 2机构 3 企业；多个逗号分隔',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='权限表';

-- ----------------------------
-- Records of permissions
-- ----------------------------
BEGIN;
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('001', '通知公告', '0', 1, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('001001', '通知公告新增', '001', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('001002', '通知公告删除', '001', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002', '一企一档', '0', 1, '2022-04-29 16:02:21', 2, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002001', '一企一档消防新增', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002002', '一企一档详情', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002003', '一企一档账号', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002004', '一企一档编辑', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002005', '一企一档删除', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002006', '一企一档鹰眼e通', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002007', '一企一档续费', '002', 2, '2022-04-29 16:02:21', 1, '1');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002008', '一企一档通讯记录', '002', 2, '2022-04-29 16:02:21', 1, '1');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002009', '一企一档市场质量监督新增', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002010', '一企一档一键开启语音和短信', '002', 2, '2022-04-29 16:02:21', 1, '1');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002011', '一企一档应急新增', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002012', '一企一档社会单位新增', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002013', '一企一档综合行政新增', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002014', '一企一档综合党政新增', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002015', '一企一档教育新增', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002016', '一企一档导入', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('002017', '一企一档模板下载', '002', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006', '系统设置', '0', 1, '2022-04-29 16:02:21', 9, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001', '部门与账号', '006', 2, '2022-04-29 16:02:21', 9, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001001', '部门新增', '006001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001002', '部门编辑', '006001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001003', '部门删除', '006001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001004', '账号新增', '006001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001005', '账号编辑', '006001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001006', '账号删除', '006001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001008', '授权', '006001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006001009', '取消授权', '006001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006002', '行政区划设置', '006', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006002001', '行政区划新增', '006002', 3, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006002002', '行政区划编辑', '006002', 3, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006002003', '行政区划删除', '006002', 3, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006003', '角色', '006', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006003001', '角色新增', '006003', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006003002', '角色编辑', '006003', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006003003', '角色删除', '006003', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006004', '首页布局', '006', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006005', '处置提醒', '006', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('006006', '大屏设置', '006', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('007', '消防物联网', '0', 1, '2022-04-29 16:02:21', 10, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('008', '电气火灾监测', '0', 1, '2022-04-29 16:02:21', 11, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('009', '建筑消防用水', '0', 1, '2022-04-29 16:02:21', 12, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('010', '智慧独立烟感', '0', 1, '2022-04-29 16:02:21', 13, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('011', '综合治理可视化', '0', 1, '2022-04-29 16:02:21', 26, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('012', '可燃气体监测', '0', 1, '2022-04-29 16:02:21', 14, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013', '智慧融媒体', '0', 1, '2022-04-29 16:02:21', 15, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001', 'IP音柱', '013', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001001', '上传', '013001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001002', '批量播放', '013001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001003', '批量终止播放', '013001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001004', '播放', '013001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001004001', '音频删除', '013001004', 4, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001005', '终止播放', '013001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001006', '设置音量', '013001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001007', '监听', '013001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013001008', '停止监听', '013001', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002', 'LED屏', '013', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002001', '上传', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002002', '批量发布', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002003', '批量停止播放', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002004', '批量开始播放', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002005', '发布', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002006', '视频', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002006001', '视频删除', '013002006', 4, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002007', '图片', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002007001', '图片删除', '013002007', 4, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002008', '文字', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002009', '停止播放', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('013002010', '开始播放', '013002', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('014', '智能灭火器监测', '0', 1, '2022-04-29 16:02:21', 16, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('015', '自动联网报警', '0', 1, '2022-04-29 16:02:21', 17, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('016', '水泵监测系统', '0', 1, '2022-04-29 16:02:21', 18, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017', '物联设备管理', '0', 1, '2022-04-29 16:02:21', 27, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017001', '设备添加', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017002', '设备导入', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017003', '设备导出', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017004', '模板下载', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017005', '设备通知', '017', 2, '2022-04-29 16:02:21', 1, '1');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017005001', '短信通知', '017005', 3, '2022-04-29 16:02:21', 1, '1');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017005002', '语音通知', '017005', 3, '2022-04-29 16:02:21', 1, '1');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017006', '设备编辑', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017007', '设备阈值', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017008', '设备删除', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017009', '控制分合闸', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017010', '证据链下载', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('017011', '消音', '017', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('018', '历史报警信息', '0', 1, '2022-04-29 16:02:21', 28, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('018001', '导出', '018', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('018002', '处置', '018', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('018003', '一键处置', '018', 2, '2022-04-29 16:02:21', 1, '1');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('018004', '消音', '018', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('019', '大数据分析', '0', 1, '2022-04-29 16:02:21', 29, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('020', '危化品企业安全', '0', 1, '2022-04-29 16:02:21', 21, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('021', '电梯安全', '0', 1, '2022-04-29 16:02:21', 20, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('022', '水域安全', '0', 1, '2022-04-29 16:02:21', 22, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('023', '慧眼识别', '0', 1, '2022-04-29 16:02:21', 19, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('024', '医院安全', '0', 1, '2022-04-29 16:02:21', 23, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('025', '可视视频', '0', 1, '2022-04-29 16:02:21', 24, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('026', '厨房安全', '0', 1, '2022-04-29 16:02:21', 25, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('027', '消防隐患', '0', 1, '2022-04-29 16:02:21', 3, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('028', '检查痕迹', '0', 1, '2022-04-29 16:02:21', 4, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029', '消防档案', '0', 1, '2022-04-29 16:02:21', 8, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029001', '企业单位档案-提交数据', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029002', '巡检点维护-巡检点设置', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029003', '巡检点维护-分区设置', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029004', '巡检点维护-编辑', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029005', '巡检点维护-删除', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029006', '单位平面图-添加', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029007', '单位平面图-编辑', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029008', '单位平面图-删除', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029009', '消防合法文书-添加', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029010', '消防合法文书-编辑', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029011', '消防合法文书-删除', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029012', '现场记录-新增', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029013', '现场记录-删除', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029014', '消防预案和演练-添加', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029015', '消防预案和演练-编辑', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029016', '消防预案和演练-删除', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029017', '消防培训-添加', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029018', '消防培训-编辑', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029019', '消防培训-删除', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029020', '规章制度-添加', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029021', '规章制度-编辑', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029022', '规章制度-删除', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029023', '值班人员', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029023001', '添加值班人员', '029023', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029023002', '编辑', '029023', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029023003', '删除', '029023', 3, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('029024', '开始值班', '029', 2, '2022-04-29 16:02:21', 1, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030', '应知应会', '0', 1, '2022-04-29 16:02:21', 30, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030001', '分类新增', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030002', '分类编辑', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030003', '分类删除', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030004', '文章新增', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030005', '文章删除', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030006', '文章编辑', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030007', '文章上线', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030008', '文章下线', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030009', '文章审核', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('030010', '评论列表', '030', 2, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('03001001', '评论添加', '030010', 3, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('03001002', '评论删除', '030010', 3, '2022-04-29 16:02:21', 1, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('031', '一键通知', '0', 1, '2022-04-29 16:02:21', 31, '1,2');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('032', '远程抄表', '0', 1, '2022-04-29 16:02:21', 32, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('033', '开关量监测', '0', 1, '2022-04-29 16:02:21', 33, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('035', '仓库安全', '0', 1, '2022-04-29 16:02:21', 35, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('036', '充电桩安全', '0', 1, '2022-04-29 16:02:21', 36, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('037', '应急指挥', '0', 1, '2024-03-22 10:09:01', 37, '1,2,3');
INSERT INTO `permissions` (`id`, `name`, `pid`, `level`, `createtime`, `sortid`, `type`) VALUES ('038', '证书管理', '0', 1, '2024-04-26 09:11:51', 38, '1,2,3');
COMMIT;

-- ----------------------------
-- Table structure for renew_info
-- ----------------------------
DROP TABLE IF EXISTS `renew_info`;
CREATE TABLE `renew_info` (
  `id` varchar(36) NOT NULL COMMENT '主键',
  `version` varchar(10) DEFAULT NULL COMMENT '版本号',
  `content` tinytext COMMENT '新增内容',
  `optimize_content` tinytext COMMENT '优化内容',
  `repair_content` tinytext COMMENT '修复内容',
  `time` varchar(50) DEFAULT NULL COMMENT '时间',
  `type` int DEFAULT NULL COMMENT '类型：1新增 2优化 3修复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='系统更新记录';

-- ----------------------------
-- Records of renew_info
-- ----------------------------
BEGIN;
INSERT INTO `renew_info` (`id`, `version`, `content`, `optimize_content`, `repair_content`, `time`, `type`) VALUES ('5ae1b501-7ba4-4fb5-a259-022e52040dc6', '2.0.1', '增加自注册功能', NULL, NULL, '2024-05-21 15:54:18', NULL);
INSERT INTO `renew_info` (`id`, `version`, `content`, `optimize_content`, `repair_content`, `time`, `type`) VALUES ('a12c4b53-e23c-45c4-8aaa-4e87f3be0695', '2.0.0', '增加通知公告滚动展示功能、优化应急指挥大屏展示、优化一企一档大屏展示、优化地图标点样式', NULL, NULL, '2024-05-21 13:55:13', NULL);
INSERT INTO `renew_info` (`id`, `version`, `content`, `optimize_content`, `repair_content`, `time`, `type`) VALUES ('af16fd60-37f7-45ab-94a9-6d688388792e', '2.0.2', '1、新增“安消无忧”模块', '', '1、修复已知bug', '2024-05-30 09:34:06', NULL);
COMMIT;

-- ----------------------------
-- Table structure for renewa_record
-- ----------------------------
DROP TABLE IF EXISTS `renewa_record`;
CREATE TABLE `renewa_record` (
  `id` varchar(36) NOT NULL COMMENT '主键id',
  `business_id` varchar(36) DEFAULT NULL COMMENT '单位id',
  `business_name` varchar(36) DEFAULT NULL COMMENT '单位名称',
  `number` varchar(5) DEFAULT NULL COMMENT '数量',
  `type` varchar(5) DEFAULT NULL COMMENT '类型',
  `time` datetime DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of renewa_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` varchar(36) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL COMMENT '名称',
  `type` varchar(10) DEFAULT NULL COMMENT '用户类型：1 机构账户  2 单位账户',
  `sortid` int DEFAULT NULL COMMENT '排序字段',
  `home_id` varchar(36) DEFAULT NULL COMMENT '归属id：单位id；'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='角色表';

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `name`, `type`, `sortid`, `home_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '管理员', '1', 1, '001e7548-8735-4b31-b30b-c9361a62c102');
COMMIT;

-- ----------------------------
-- Table structure for rolepermission
-- ----------------------------
DROP TABLE IF EXISTS `rolepermission`;
CREATE TABLE `rolepermission` (
  `role_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '角色id',
  `permission_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '权限id'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='角色权限表';

-- ----------------------------
-- Records of rolepermission
-- ----------------------------
BEGIN;
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '031');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002004');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002005');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002006');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002007');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002008');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002009');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002010');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002011');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002012');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002013');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002014');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002015');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001004');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001005');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001006');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006002001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006002002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006002003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006003001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006003002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006003003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006004');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '007');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '008');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '009');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '010');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '012');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001004');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001004001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001005');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001006');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001007');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013001008');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002004');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002005');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002006');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002006001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002007');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002007001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002008');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002009');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013002010');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '014');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '015');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '016');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017004');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017005');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017005001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017005002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017006');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017007');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017008');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017009');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017010');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '017011');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '018');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '018001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '018002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '018003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '018004');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '019');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '020');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '021');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '022');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '023');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '025');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '027');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030005');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030006');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030007');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030008');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030009');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030003');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030004');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '030010');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '03001001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '03001002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '001001');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '001002');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002016');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '002017');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006005');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '033');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006006');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '032');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '026');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '013');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001008');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '006001009');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '035');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '036');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '037');
INSERT INTO `rolepermission` (`role_id`, `permission_id`) VALUES ('001e7548-8735-4b31-b30b-c9361a62c901', '038');
COMMIT;

-- ----------------------------
-- Table structure for texttitle
-- ----------------------------
DROP TABLE IF EXISTS `texttitle`;
CREATE TABLE `texttitle` (
  `id` varchar(36) NOT NULL COMMENT '主键',
  `home_id` varchar(36) DEFAULT NULL COMMENT '机构id',
  `device_classify` varchar(3) DEFAULT NULL COMMENT '属性标识',
  `title_text` varchar(20) DEFAULT NULL COMMENT '标题名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of texttitle
-- ----------------------------
BEGIN;
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('08ec77c7-6357-4eca-a372-86a225e42f38', '9e7631e3-0a48-4026-b0d7-feef2319d904', '100', '消防物联网值守平台');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('126746d7-3737-403f-970c-e6d7a6c122d4', '001e7548-8735-4b31-b30b-c9361a62c102', '1', '电气火灾监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('1517223f-c331-44f9-85e8-69137d2f8a21', '9e7631e3-0a48-4026-b0d7-feef2319d904', '10', '水泵检测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('21e4ab87-1c0d-4c55-86e3-2bb70f9a477c', '001e7548-8735-4b31-b30b-c9361a62c155', '8', '世成水泵检测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('228416a2-963a-4ddb-bb59-2424acd81da1', '001e7548-8735-4b31-b30b-c9361a62c155', '100', '消防物联网值守平台');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('23728c0c-1ac7-443d-8094-32ad01cf5d94', '9e7631e3-0a48-4026-b0d7-feef2319d904', '5', '自动联网报警');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('2bdf4076-1af5-404b-a2e6-7b4df5e43201', '001e7548-8735-4b31-b30b-c9361a62c102', '10', '水泵监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('2dd7a606-9fc1-40c3-a367-6526751a1042', '001e7548-8735-4b31-b30b-c9361a62c102', '8', '水泵检测系统1');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('2f469b7c-de41-4e9c-91f0-d47222266089', '001e7548-8735-4b31-b30b-c9361a62c155', '0', '世成智慧消防监管云平台');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('3013eb7a-430e-446f-84fb-14702a255255', '001e7548-8735-4b31-b30b-c9361a62c159', '7', '智能灭火器监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('31ecc292-da8f-46ee-a860-dad2eb0cf906', '001e7548-8735-4b31-b30b-c9361a62c102', '7', '智能灭火器监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('32e44421-bfca-425a-a158-de5982a1b1fc', '001e7548-8735-4b31-b30b-c9361a62c155', '6', '可视化报警监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('337b9cf9-98ca-4ada-ba2b-7f4a3cfeceb4', '001e7548-8735-4b31-b30b-c9361a62c155', '7', '智能灭火器监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('35321e6c-1a2c-48ef-8b97-46f76147a791', '001e7548-8735-4b31-b30b-c9361a62c159', '6', '可视化报警监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('3b552d69-37c9-4c13-a8fe-936c66fa2f9f', '495f6d11-1133-465a-9359-f4d240ea7694', '5', '自动联网报警');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('3d55715e-1d4c-41fd-9dd3-ba2925980502', '001e7548-8735-4b31-b30b-c9361a62c155', '1', '电气火灾监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('3e857250-1374-4744-ad35-8ee40392eb5d', '001e7548-8735-4b31-b30b-c9361a62c159', '4', '可燃气体监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('42ef8bb0-ae2d-4435-ab0c-83c93b2d9465', '495f6d11-1133-465a-9359-f4d240ea7694', '100', '消防物联网值守平台');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('43083817-3a5f-422c-893c-e5bff1e65085', '001e7548-8735-4b31-b30b-c9361a62c159', '5', '自动联网报警');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('45a0dbb1-4f9e-422a-8a26-fc8bbaec479c', '001e7548-8735-4b31-b30b-c9361a62c155', '4', '可燃气体监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('51b0fca3-22bc-4679-911b-6c906b458867', '001e7548-8735-4b31-b30b-c9361a62c102', '4', '可燃气体监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('525d91fc-f512-4d7e-9bae-f32c85b636b8', '495f6d11-1133-465a-9359-f4d240ea7694', '7', '智能灭火器监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('55ae79be-f239-4616-9a01-9b3005333274', '001e7548-8735-4b31-b30b-c9361a62c102', '0', '公共环境安全云平台');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('5e9837d2-9f87-4b54-bc1b-643e73b0cbba', '9e7631e3-0a48-4026-b0d7-feef2319d904', '4', '可燃气体监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('6152ce64-1deb-4319-bbf4-00e40db2a427', '001e7548-8735-4b31-b30b-c9361a62c159', '3', '独立烟感报警监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('659c3eb2-406d-4131-ac01-a2d2d445115b', '9e7631e3-0a48-4026-b0d7-feef2319d904', '7', '智能灭火器监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('66e69d36-9a80-4e1e-be9a-98dc2534c6ef', '001e7548-8735-4b31-b30b-c9361a62c102', '100', '值守中心');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('670b4e7d-8d92-4b5c-ad29-63898611ccf3', '495f6d11-1133-465a-9359-f4d240ea7694', '3', '独立烟感报警监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('736ddbcc-52b6-4c47-830c-68881cab304e', '495f6d11-1133-465a-9359-f4d240ea7694', '6', '可视化报警监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('75e67bc3-04e2-4bc8-ace1-f63cc371981e', '495f6d11-1133-465a-9359-f4d240ea7694', '4', '可燃气体监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('760d07d4-ee3f-4840-971c-673cce3f0f75', '9e7631e3-0a48-4026-b0d7-feef2319d904', '6', '加油站视频预警');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('8867441a-62f6-4b7f-b9f5-cd0cbe6bd3c6', '495f6d11-1133-465a-9359-f4d240ea7694', '2', '建筑消防用水监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('8b1b3f96-5bdc-4ef6-be56-6c16767f0517', '001e7548-8735-4b31-b30b-c9361a62c159', '2', '建筑消防用水监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('8e9a571d-72de-47f3-a076-57de119b0e1e', '001e7548-8735-4b31-b30b-c9361a62c155', '2', '建筑消防用水监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('90c4111b-e7ef-4f3d-a6f9-858ecbe3294d', '001e7548-8735-4b31-b30b-c9361a62c102', '6', '鹰眼监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('945c7095-7edb-41c8-b898-98ffab99b5b3', '001e7548-8735-4b31-b30b-c9361a62c102', '3', '独立烟感监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('b3b63861-4889-4a96-b5f3-93c1816de748', '9e7631e3-0a48-4026-b0d7-feef2319d904', '2', '建筑消防用水监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('b3c87d0b-51a8-47ca-960f-0aaaa67ff9d9', '001e7548-8735-4b31-b30b-c9361a62c159', '1', '智慧用电监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('b57276b1-1a6a-4171-87dd-b8af86e6e1c1', '9e7631e3-0a48-4026-b0d7-feef2319d904', '3', '独立烟感报警监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('b7ba38d2-3ef1-4c1f-a14a-3cb10899d560', '001e7548-8735-4b31-b30b-c9361a62c159', '100', '消防物联网值守平台');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('b9a5085a-9204-41da-ae6f-ac77b143e678', '001e7548-8735-4b31-b30b-c9361a62c159', '0', '公共环境安全监管云平台');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('bc15a995-5f71-4ec1-9b2c-0d8a43dcab60', '495f6d11-1133-465a-9359-f4d240ea7694', '1', '电气火灾监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('bf1237bc-9cc7-4558-915f-3228d82fe9a1', '495f6d11-1133-465a-9359-f4d240ea7694', '8', '水泵检测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('c09498c3-9d08-4a51-babd-c045fa9d50ac', '001e7548-8735-4b31-b30b-c9361a62c102', '5', '自动联网报警');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('cd7f52e9-a027-4f8d-85c5-4b3875996f21', '495f6d11-1133-465a-9359-f4d240ea7694', '0', '公共环境安全监管云平台');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('d0a07fbb-6e88-4f8d-857a-ebea580d0d04', '001e7548-8735-4b31-b30b-c9361a62c159', '8', '大型设备状态监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('d3142dc9-b4c3-49fc-a296-c4a2d33a8a2c', '9e7631e3-0a48-4026-b0d7-feef2319d904', '0', '智慧加油站安全生产风险预警系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('d9ef91ff-f85a-42ed-b431-a8dc59c76532', '001e7548-8735-4b31-b30b-c9361a62c155', '3', '独立烟感报警监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('e0a8c490-f9c6-448e-a52a-25ca7f793e4b', '001e7548-8735-4b31-b30b-c9361a62c102', '2', '建筑用水监测系统');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('f0eebcb5-d761-4d3a-beb9-7e276545f02f', '001e7548-8735-4b31-b30b-c9361a62c155', '5', '自动联网报警');
INSERT INTO `texttitle` (`id`, `home_id`, `device_classify`, `title_text`) VALUES ('f4b08713-86fb-4658-a18c-2113440f781f', '9e7631e3-0a48-4026-b0d7-feef2319d904', '1', '电气火灾监测系统');
COMMIT;

-- ----------------------------
-- Table structure for titlepicture
-- ----------------------------
DROP TABLE IF EXISTS `titlepicture`;
CREATE TABLE `titlepicture` (
  `id` varchar(36) NOT NULL COMMENT '主键',
  `file_path` varchar(255) DEFAULT NULL COMMENT '标题地址',
  `home_id` varchar(36) DEFAULT NULL COMMENT '机构id',
  `type` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of titlepicture
-- ----------------------------
BEGIN;
INSERT INTO `titlepicture` (`id`, `file_path`, `home_id`, `type`) VALUES ('1', 'https://xf.wiscloud.online/uploads/title/zhejiangjuyi.png', '001e7548-8735-4b31-b30b-c9361a62c158', '2');
INSERT INTO `titlepicture` (`id`, `file_path`, `home_id`, `type`) VALUES ('2', 'https://xf.wiscloud.online/uploads/title/default.png', NULL, '2');
INSERT INTO `titlepicture` (`id`, `file_path`, `home_id`, `type`) VALUES ('3', 'https://xf.wiscloud.online/uploads/title/gonggonghuanjinganquanjianguanyunpingtai.png', NULL, '1');
COMMIT;

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
  `keys` varchar(500) DEFAULT NULL,
  `values` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of token
-- ----------------------------
BEGIN;
INSERT INTO `token` (`keys`, `values`) VALUES ('eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc1VzZSI6MSwicmVnaW5pZCI6IjAiLCJob21lX2lkIjoiMDAxZTc1NDgtODczNS00YjMxLWIzMGItYzkzNjFhNjJjMTAyIiwiaWQiOiI5MzBkMmU4NS0yZDVkLTRiZTktYjgzMS1lZjcyOTBhMmNmN2YiLCJ0eXBlIjoxLCJleHAiOjE3NDI2Mjk4MDd9.qROrK5TbuTseP796nXVz3-QB57qpYy3WVGoPQ0bIyxo', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc1VzZSI6MSwicmVnaW5pZCI6IjAiLCJob21lX2lkIjoiMDAxZTc1NDgtODczNS00YjMxLWIzMGItYzkzNjFhNjJjMTAyIiwiaWQiOiI5MzBkMmU4NS0yZDVkLTRiZTktYjgzMS1lZjcyOTBhMmNmN2YiLCJ0eXBlIjoxLCJleHAiOjE3NDAwNTk0MDd9.8O-EOuLBVLs8tjpsc8S_H9SqEQbm7SSveDmf1eLBq9c');
INSERT INTO `token` (`keys`, `values`) VALUES ('eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc1VzZSI6MSwicmVnaW5pZCI6IjAiLCJob21lX2lkIjoiMDAxZTc1NDgtODczNS00YjMxLWIzMGItYzkzNjFhNjJjMTAyIiwiaWQiOiI5MzBkMmU4NS0yZDVkLTRiZTktYjgzMS1lZjcyOTBhMmNmN2YiLCJ0eXBlIjoxLCJleHAiOjE3NDAwNTk0MDd9.8O-EOuLBVLs8tjpsc8S_H9SqEQbm7SSveDmf1eLBq9c', '1');
COMMIT;

-- ----------------------------
-- Table structure for topped_application_info
-- ----------------------------
DROP TABLE IF EXISTS `topped_application_info`;
CREATE TABLE `topped_application_info` (
  `user_id` varchar(36) DEFAULT NULL COMMENT '用户ID',
  `module_id` varchar(500) DEFAULT NULL COMMENT '模块ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='置顶应用信息';

-- ----------------------------
-- Records of topped_application_info
-- ----------------------------
BEGIN;
INSERT INTO `topped_application_info` (`user_id`, `module_id`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '6666');
INSERT INTO `topped_application_info` (`user_id`, `module_id`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '[{\"ischeck\":true,\"role\":\"008\",\"bg\":[\"#FD7D75\",\"#FC602B\"],\"icon\":\"firefighting-fire\",\"type\":\"fire\"}]');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键id',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '真实姓名',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号码',
  `home_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '归属id：单位id或者机构id',
  `department_id` varchar(36) DEFAULT NULL COMMENT '部门id',
  `email` varchar(100) DEFAULT NULL COMMENT '电子邮箱',
  `accountname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '登录账号',
  `accountpassword` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '登录密码',
  `is_use` int DEFAULT NULL COMMENT '是否在用：1 启用  2 停用',
  `createtime` datetime DEFAULT NULL COMMENT '创建时间',
  `type` int DEFAULT NULL COMMENT '账户类型：1 机构账户  2 单位账户',
  `cid` varchar(36) DEFAULT NULL COMMENT 'app的cid',
  `role_id` varchar(36) DEFAULT NULL COMMENT '角色id',
  `home_name` varchar(255) DEFAULT NULL COMMENT '隶属单位、机构名称',
  `open_maintenance` varchar(1) DEFAULT NULL COMMENT '是否可以跳转维保系统：1可以 2不可以',
  `Exhibition_type` int DEFAULT NULL COMMENT '账号展示类型：1是展示 2或null不是展示',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `name`, `phone`, `home_id`, `department_id`, `email`, `accountname`, `accountpassword`, `is_use`, `createtime`, `type`, `cid`, `role_id`, `home_name`, `open_maintenance`, `Exhibition_type`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '管理员', '18660105865', '001e7548-8735-4b31-b30b-c9361a62c102', NULL, 'aa@aa.com', 'admin', '4f785465c89a9ef0c25cc6b775ffffb390cf50bf6509f813:ac02bf88c0f54b1b3bddf1d6f2765208798cdc56c2d70755', 1, '2020-05-09 12:43:48', 1, '', '001e7548-8735-4b31-b30b-c9361a62c901', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for userpermission
-- ----------------------------
DROP TABLE IF EXISTS `userpermission`;
CREATE TABLE `userpermission` (
  `user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户id',
  `permission_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '权限id',
  `createtime` datetime DEFAULT NULL COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='用户权限表（此表为单位用户所用）';

-- ----------------------------
-- Records of userpermission
-- ----------------------------
BEGIN;
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '031', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '001001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '001002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002005', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002007', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002008', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002009', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002010', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002011', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002012', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002013', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002014', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002015', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001005', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006002001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006002002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006002003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006003001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006003002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006003003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '007', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '008', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '009', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '010', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '012', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001004001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001005', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001007', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013001008', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002005', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002006001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002007', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002007001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002008', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002009', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013002010', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '014', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '015', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '016', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017005', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017005001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017005002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017007', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017008', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017009', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017010', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '017011', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '018', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '018001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '018002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '018003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '018004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '019', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '020', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '021', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '022', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '023', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '025', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '027', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '028', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029005', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029007', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029008', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029009', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029010', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029011', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029012', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029013', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029014', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029015', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029016', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029017', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029018', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029019', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029020', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029021', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029022', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029023', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029023001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029023002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029023003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '029024', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030005', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030007', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030008', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030009', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030003', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030004', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '030010', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '03001001', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '03001002', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002016', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '002017', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '033', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006005', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006006', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '032', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '011', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '024', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '026', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '013', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001008', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '006001009', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '035', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '036', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '037', NULL);
INSERT INTO `userpermission` (`user_id`, `permission_id`, `createtime`) VALUES ('930d2e85-2d5d-4be9-b831-ef7290a2cf7f', '038', NULL);
COMMIT;

-- ----------------------------
-- Table structure for userrole
-- ----------------------------
DROP TABLE IF EXISTS `userrole`;
CREATE TABLE `userrole` (
  `user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户id',
  `role_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '角色id',
  `createtime` datetime DEFAULT NULL COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='用户角色表';

-- ----------------------------
-- Records of userrole
-- ----------------------------
BEGIN;
INSERT INTO `userrole` (`user_id`, `role_id`, `createtime`) VALUES ('6', '1', '2020-06-02 14:20:38');
INSERT INTO `userrole` (`user_id`, `role_id`, `createtime`) VALUES ('5', '4', '2020-06-02 14:20:40');
INSERT INTO `userrole` (`user_id`, `role_id`, `createtime`) VALUES ('2', '6', '2020-06-02 14:20:42');
COMMIT;

-- ----------------------------
-- Table structure for wechat
-- ----------------------------
DROP TABLE IF EXISTS `wechat`;
CREATE TABLE `wechat` (
  `id` varchar(36) DEFAULT NULL,
  `user_id` varchar(36) DEFAULT NULL,
  `open_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of wechat
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wechat_code
-- ----------------------------
DROP TABLE IF EXISTS `wechat_code`;
CREATE TABLE `wechat_code` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键id',
  `json_data` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'code数据',
  `time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of wechat_code
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
